IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'VirtualServerBindingsCreate')
	BEGIN
		DROP  Procedure  VirtualServerBindingsCreate
	END

GO

CREATE Procedure VirtualServerBindingsCreate
(
	@virtualServerId int,
	@hostname nvarchar(200),
	@ipAddress nvarchar(15),
	@port int,
	@virtualServerBindingId int OUTPUT
)
AS

INSERT INTO VirtualServerBindings
	(VirtualServerId, Hostname, IpAddress, Port)
VALUES
	(@virtualServerId, @hostname, @ipAddress, @port)

SET @virtualServerBindingId = SCOPE_IDENTITY()

GO